Subject | Re: [firebird-support] Database ... Shutdown |
---|---|
Author | Ivan Grozny |
Post date | 2006-12-31T19:48:59Z |
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]
----- 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]