Subject Re: [firebird-support] Database ... Shutdown
Author Ivan Grozny
Yet another victim of Yahoo! groups... this message is dated Dec 21, but I (and I presume everyone else) am only seeing it on the 31st. I personally don't have an answer for the question, but I'd like the OP to know he's not being ignored - just not heard until now...

----- Original Message ----
From: Thomas Gustavo Dietrich <thomasgustavo@...>
To: firebird-support@yahoogroups.com
Sent: Thursday, December 21, 2006 10:36:46 AM
Subject: [firebird-support] Database ... Shutdown













Error while connect to Firebird 2 from Java / Jaybird.

I made this class:



************ *******



import java.sql.Connection ;

import java.sql.DriverMana ger;

import java.sql.ResultSet;

import java.sql.SQLExcepti on;

import java.sql.Statement;

import java.util.Propertie s;



public class TesteFirebird {

public static void main(String[ ] args) {

try{

Connection con1 = getConnection( );

Connection con2 = getConnection( );



Statement st1 = con1.createStatemen t();

ResultSet rs1 = st1.executeQuery( "select * from usuarios;" );

rs1.next();

System.out.println( "rs1 try 1: " + rs1.getString( 1 ) );



Statement st2 = con2.createStatemen t();

ResultSet rs2 = st2.executeQuery( "select * from empregados;" );

rs2.next();

System.out.println( "rs2: " + rs2.getString( 1 ) );



rs1.next();

System.out.println( "rs1 try 2: " + rs1.getString( 1 ) );

} catch (Exception e) {

e.printStackTrace( );

}

}



private static Connection getConnection( ) throws SQLException,

ClassNotFoundExcept ion{

Class.forName( "org.firebirdsql .jdbc.FBDriver" );

Properties props = new Properties() ;

props.setProperty( "user", "SYSDBA");

props.setProperty( "password" , "masterkey" );

props.setProperty( "encoding" , "ISO8859_1" );



return DriverManager. getConnection(

"jdbc:firebirdsql: 127.0.0.1: /home/thomas/ test.fdb" , props );

}

}



************ *******



and occurs this error:



************ *******



org.firebirdsql. jdbc.FBSQLExcept ion: GDS Exception. 335544528.

database /home/thomas/ test.fdb shutdown

Reason: database /home/thomas/ test.fdb shutdown

at org.firebirdsql. jdbc.FBDataSourc e.getConnection( FBDataSource. java:122)

at org.firebirdsql. jdbc.FBDriver. connect(FBDriver .java:131)

at java.sql.DriverMana ger.getConnectio n(DriverManager. java:525)

at java.sql.DriverMana ger.getConnectio n(DriverManager. java:140)

at TesteFirebird. getConnection( TesteFirebird. java:38)

at TesteFirebird. main(TesteFirebi rd.java:12)

at org.firebirdsql. gds.GDSException : database /home/thomas/ test.fdb shutdown

at org.firebirdsql. gds.impl. wire.AbstractJav aGDSImpl. readStatusVector (AbstractJavaGDS Impl.java: 2124)

at org.firebirdsql. gds.impl. wire.AbstractJav aGDSImpl. receiveResponse( AbstractJavaGDSI mpl.java: 2074)

at org.firebirdsql. gds.impl. wire.AbstractJav aGDSImpl. internalAttachDa tabase(AbstractJ avaGDSImpl. java:414)

at org.firebirdsql. gds.impl. wire.AbstractJav aGDSImpl. iscAttachDatabas e(AbstractJavaGD SImpl.java: 370)

at org.firebirdsql. jca.FBManagedCon nection.< init>(FBManagedC onnection. java:89)

at org.firebirdsql. jca.FBManagedCon nectionFactory. createManagedCon nection(FBManage dConnectionFacto ry.java:470)

at org.firebirdsql. jca.FBStandAlone ConnectionManage r.allocateConnec tion(FBStandAlon eConnectionManag er.java:69)

at org.firebirdsql. jdbc.FBDataSourc e.getConnection( FBDataSource. java:119)

at org.firebirdsql. jdbc.FBDriver. connect(FBDriver .java:131)

at java.sql.DriverMana ger.getConnectio n(DriverManager. java:525)

at java.sql.DriverMana ger.getConnectio n(DriverManager. java:140)

at TesteFirebird. getConnection( TesteFirebird. java:38)

at TesteFirebird. main(TesteFirebi rd.java:12)



************ *******



Somebody help me?

[]'s












<!--

#ygrp-mlmsg {font-size:13px;font-family:arial,helvetica,clean,sans-serif;}
#ygrp-mlmsg table {font-size:inherit;font:100%;}
#ygrp-mlmsg select, input, textarea {font:99% arial,helvetica,clean,sans-serif;}
#ygrp-mlmsg pre, code {font:115% monospace;}
#ygrp-mlmsg * {line-height:1.22em;}
#ygrp-text{
font-family:Georgia;
}
#ygrp-text p{
margin:0 0 1em 0;
}
#ygrp-tpmsgs{
font-family:Arial;
clear:both;
}
#ygrp-vitnav{
padding-top:10px;
font-family:Verdana;
font-size:77%;
margin:0;
}
#ygrp-vitnav a{
padding:0 1px;
}
#ygrp-actbar{
clear:both;
margin:25px 0;
white-space:nowrap;
color:#666;
text-align:right;
}
#ygrp-actbar .left{
float:left;
white-space:nowrap;
}
.bld{font-weight:bold;}
#ygrp-grft{
font-family:Verdana;
font-size:77%;
padding:15px 0;
}
#ygrp-ft{
font-family:verdana;
font-size:77%;
border-top:1px solid #666;
padding:5px 0;
}
#ygrp-mlmsg #logo{
padding-bottom:10px;
}

#ygrp-vital{
background-color:#e0ecee;
margin-bottom:20px;
padding:2px 0 8px 8px;
}
#ygrp-vital #vithd{
font-size:77%;
font-family:Verdana;
font-weight:bold;
color:#333;
text-transform:uppercase;
}
#ygrp-vital ul{
padding:0;
margin:2px 0;
}
#ygrp-vital ul li{
list-style-type:none;
clear:both;
border:1px solid #e0ecee;
}
#ygrp-vital ul li .ct{
font-weight:bold;
color:#ff7900;
float:right;
width:2em;
text-align:right;
padding-right:.5em;
}
#ygrp-vital ul li .cat{
font-weight:bold;
}
#ygrp-vital a {
text-decoration:none;
}

#ygrp-vital a:hover{
text-decoration:underline;
}

#ygrp-sponsor #hd{
color:#999;
font-size:77%;
}
#ygrp-sponsor #ov{
padding:6px 13px;
background-color:#e0ecee;
margin-bottom:20px;
}
#ygrp-sponsor #ov ul{
padding:0 0 0 8px;
margin:0;
}
#ygrp-sponsor #ov li{
list-style-type:square;
padding:6px 0;
font-size:77%;
}
#ygrp-sponsor #ov li a{
text-decoration:none;
font-size:130%;
}
#ygrp-sponsor #nc {
background-color:#eee;
margin-bottom:20px;
padding:0 8px;
}
#ygrp-sponsor .ad{
padding:8px 0;
}
#ygrp-sponsor .ad #hd1{
font-family:Arial;
font-weight:bold;
color:#628c2a;
font-size:100%;
line-height:122%;
}
#ygrp-sponsor .ad a{
text-decoration:none;
}
#ygrp-sponsor .ad a:hover{
text-decoration:underline;
}
#ygrp-sponsor .ad p{
margin:0;
}
o {font-size:0;}
.MsoNormal {
margin:0 0 0 0;
}
#ygrp-text tt{
font-size:120%;
}
blockquote{margin:0 0 0 4px;}
.replbq {margin:4;}
-->







__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

[Non-text portions of this message have been removed]