You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@commons.apache.org by bu...@apache.org on 2006/03/15 21:00:29 UTC
DO NOT REPLY [Bug 38987] New: - commons dbcp does not supports Firebird DB.
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG�
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=38987>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND�
INSERTED IN THE BUG DATABASE.
http://issues.apache.org/bugzilla/show_bug.cgi?id=38987
Summary: commons dbcp does not supports Firebird DB.
Product: Commons
Version: unspecified
Platform: PC
OS/Version: Windows XP
Status: NEW
Severity: normal
Priority: P2
Component: Dbcp
AssignedTo: commons-dev@jakarta.apache.org
ReportedBy: master_temp@tut.by
I'm trying to use Torque-3.2 with open-source Firebird DBMS, but simple example
not works. Here is the log output:
15.03.2006 21:47:38 org.apache.torque.dsfactory.AbstractDataSourceFactory
setProperty
SEVERE: Property: driver value: org.firebirdsql.jdbc.FBDriver is not supported
by DataSource: org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS
--
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.
---------------------------------------------------------------------
To unsubscribe, e-mail: commons-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-dev-help@jakarta.apache.org
DO NOT REPLY [Bug 38987] - [dbcp] commons dbcp does not supports Firebird DB.
Posted by bu...@apache.org.
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG�
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=38987>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND�
INSERTED IN THE BUG DATABASE.
http://issues.apache.org/bugzilla/show_bug.cgi?id=38987
sjr@jdns.org changed:
What |Removed |Added
----------------------------------------------------------------------------
Summary|commons dbcp does not |[dbcp] commons dbcp does not
|supports Firebird DB. |supports Firebird DB.
--
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.
---------------------------------------------------------------------
To unsubscribe, e-mail: commons-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-dev-help@jakarta.apache.org
DO NOT REPLY [Bug 38987] - commons dbcp does not supports Firebird DB.
Posted by bu...@apache.org.
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG�
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=38987>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND�
INSERTED IN THE BUG DATABASE.
http://issues.apache.org/bugzilla/show_bug.cgi?id=38987
------- Additional Comments From sjr@jdns.org 2006-03-15 21:01 -------
Where can I find the source for the simple example?
--
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.
---------------------------------------------------------------------
To unsubscribe, e-mail: commons-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-dev-help@jakarta.apache.org
DO NOT REPLY [Bug 38987] - commons dbcp does not supports Firebird DB.
Posted by bu...@apache.org.
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG�
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=38987>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND�
INSERTED IN THE BUG DATABASE.
http://issues.apache.org/bugzilla/show_bug.cgi?id=38987
------- Additional Comments From master_temp@tut.by 2006-03-15 21:14 -------
(In reply to comment #1)
vampire-schema.xml
<?xml version="1.0" encoding="ISO-8859-1" standalone="no"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database_3_1.dtd">
<database name="vampire" defaultIdMethod="idbroker"
package="dmol.sharevampire.db.om" defaultJavaNamingMethod="javaname">
<table name="HOST" javaName="Host">
<column name="id" required="true" primaryKey="true" type="INTEGER"/>
<column name="hostname" required="false" type="VARCHAR" size="25"></column>
<column name="ipaddr" required="true" type="VARCHAR" size="15"></column>
<column name="lastscan" required="true" type="TIMESTAMP"></column>
</table>
<table name="NETFILE" javaName="NetFile">
<column name="id" required="true" primaryKey="true" type="INTEGER"/>
<column name="hostid" required="true" type="INTEGER"></column>
<column name="fullname" required="true" type="VARCHAR" size="1000"></column>
<column name="filesize" required="true" type="INTEGER"></column>
<column name="stamp" required="true" type="TIMESTAMP"></column>
<column name="protocol" required="true" type="VARCHAR" size="3"></column>
<foreign-key foreignTable="HOST">
<reference foreign="id" local="hostid"/>
</foreign-key>
</table>
</database>
===================
build.properties (torque-generator)
torque.project = vampire
torque.database = interbase
torque.targetPackage = dmol.vampire.db.om
torque.addGetByNameMethod = true
torque.addIntakeRetrievable = false
torque.addSaveMethod = true
torque.addTimeStamp = true
torque.basePrefix = Base
torque.complexObjectModel = true
torque.useClasspath = true
torque.useManagers = false
torque.objectIsCaching = true
torque.silentDbFetch = true
torque.generateBeans = false
torque.beanSuffix = Bean
torque.database.createUrl =
jdbc:firebirdsql:localhost/3050:D:/development/dbms/Firebird_1_5/security.fdb
torque.database.buildUrl =
jdbc:firebirdsql:localhost/3050:D:/development/dbms/Firebird_1_5/data/VAMPIRE.FDB
torque.database.url =
jdbc:firebirdsql:localhost/3050:D:/development/dbms/Firebird_1_5/data/VAMPIRE.FDB
torque.database.driver = org.firebirdsql.jdbc.FBDriver
torque.database.user = sysdba
torque.database.password = masterkey
torque.database.host = 127.0.0.1
torque.sameJavaName = false
#my
torque.output.dir = ../generated
torque.schema.dir = ../src/schema
===================
torque.properties (torque-runtime)
torque.database.default = vampire
torque.database.vampire.adapter = interbase
#Using commons-dbcp
torque.dsfactory.vampire.factory =
org.apache.torque.dsfactory.PerUserPoolDataSourceFactory
torque.dsfactory.vampire.connection.driver = org.firebirdsql.jdbc.FBDriver
torque.dsfactory.vampire.connection.url =
jdbc:firebirdsql:localhost/3050:D:/development/dbms/Firebird_1_5/data/VAMPIRE.FDB
torque.dsfactory.vampire.connection.user = dmol
torque.dsfactory.vampire.connection.password = arrrgh
torque.manager.useCache = true
===================
DdOmTests.java (test)
package dmol.sharevampire.db.om;
import java.net.InetAddress;
import java.util.Date;
import org.apache.torque.Torque;
import junit.framework.TestCase;
public class DdOmTests extends TestCase {
public void test() throws Exception{
Torque.init("torque.properties");
Host host = new Host();
InetAddress myaddr = InetAddress.getLocalHost();
host.setHostname(myaddr.getHostName());
host.setIpaddr(myaddr.getHostAddress());
host.setLastscan(new Date());
host.save();
}
}
--
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.
---------------------------------------------------------------------
To unsubscribe, e-mail: commons-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-dev-help@jakarta.apache.org