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