Hello
I'm new in Symfony. I have problems whe I try to retrieval data of an
pre-existing data base table in oracle 10g. I TEST THE CONNECTION WITH ORACLE
AND IT WORKING VERY WELL.
Please, I will appreciate so much any help with you.
My configuration is :
Apache 2.0.63
php 5.2.13
OS: Windows XP SP3
Data Base: Oracle 10g - 10.2.0.1.0
The Oracle table is:
Column Name DATATYPE NULL
ID_ORGANIZACION NUMBER (10) No
C_ORGANIZACION VARCHAR2 (10 Byte) Yes
D_ORGANIZACION VARCHAR2 (40 Byte) Yes
D_DIRECCION_FISCAL VARCHAR2 (240 Byte) Yes
C_RIF VARCHAR2 (20 Byte) Yes
C_CLASE_ORGANIZACION VARCHAR2 (20 Byte) Yes
D_PAGINA_WEB VARCHAR2 (100 Byte) Yes
C_ACCESO VARCHAR2 (20 Byte) Yes
F_CAPTURA DATE Yes
C_IDENTI_CAPTURA VARCHAR2 (20 Byte) Yes
F_ACTZCN DATE Yes
C_IDENTI_ACTZCN VARCHAR2 (20 Byte) Yes
ID_ORGANIZACION is the primary key in oracle.
SMIS_SIS_ORGANIOZACION IS THE ORACLE SYNONYM OF SMI_SIS_ORACLE.
My definition in doctrine schema.yml is:
smis_sis_organizacion:
columns:
Id_ORGANIZACION: { type: integer, primary: true }
C_ORGANIZACION: { type: string(10) }
D_ORGANIZACION: { type: string(40) }
D_DIRECCION_FISCAL: { type: string(240) }
C_RIF: { type: string(20) }
C_CLASE_ORGANIZACION: { type: string(20) }
D_PAGINA_WEB: { type: string(100) }
C_ACCESO: { type: string(20) }
F_CAPTURA : { type: timestamp, notnull: true }
C_IDENTI_CAPTURA: { type: string(20), notnull: true }
F_ACTZCN: { type: timestamp, notnull: true }
C_IDENTI_ACTZCN: { type: string(20), notnull: true }
I CALL THE PAGE WITH RETRIEVE INFORMATION OF THIS TABLE USING:
http://sm-143c0295bc7c/frontend_dev.php/ORGANIZACION
I GET THIS NEXT ERROR:
500 | Internal Server Error |
Doctrine_Record_UnknownPropertyException
Unknown record property / related component
"corganizacion" on "smis_sis_organizacion"
stack trace
* at ()
in
SF_ROOT_DIR\lib\vendor\symfony\lib\plugins\sfDoctrinePlugin\lib\vendor\doctrine\Doctrine\Record\Filter\Standard.php
line 55 ...
1. */
2. public function filterGet(Doctrine_Record $record, $name)
3. {
4. throw new
Doctrine_Record_UnknownPropertyException(sprintf('Unknown record property /
related component "%s" on "%s"', $name, get_class($record)));
5. }
6. }
* at
Doctrine_Record_Filter_Standard->filterGet(object('smis_sis_organizacion'),
'corganizacion')
in
SF_ROOT_DIR\lib\vendor\symfony\lib\plugins\sfDoctrinePlugin\lib\vendor\doctrine\Doctrine\Record.php
line 1384 ...
1. $success = false;
2. foreach ($this->_table->getFilters() as $filter) {
3. try {
4. $value = $filter->filterGet($this, $fieldName);
5. $success = true;
6. } catch (Doctrine_Exception $e) {}
7. }
* at Doctrine_Record->_get('corganizacion', 1)
in
SF_ROOT_DIR\lib\vendor\symfony\lib\plugins\sfDoctrinePlugin\lib\vendor\doctrine\Doctrine\Record.php
line 1339 ...
1. return $this->$accessor($load);
2. }
3. }
4. return $this->_get($fieldName, $load);
5. }
6.
7. protected function _get($fieldName, $load = true)
* at Doctrine_Record->get('corganizacion')
in n/a line n/a ...
* at call_user_func_array(array(object('smis_sis_organizacion'),
'get'), array('corganizacion'))
in
SF_ROOT_DIR\lib\vendor\symfony\lib\plugins\sfDoctrinePlugin\lib\record\sfDoctrineRecord.class.php
line 212 ...
1. return call_user_func_array(
2. array($this, $verb),
3. array_merge(array($entityName), $arguments)
4. );
5. } else {
6. $failed = true;
7. }
* at sfDoctrineRecord->__call('getCORGANIZACION', array())
in n/a line n/a ...
* at smis_sis_organizacion->getCORGANIZACION()
in n/a line n/a ...
* at call_user_func_array(array(object('smis_sis_organizacion'),
'getCORGANIZACION'), array())
in
SF_ROOT_DIR\lib\vendor\symfony\lib\escaper\sfOutputEscaperObjectDecorator.class.php
line 64 ...
1. $escapingMethod = $this->escapingMethod;
2. }
3.
4. $value = call_user_func_array(array($this->value, $method),
$args);
5.
6. return sfOutputEscaper::escape($escapingMethod, $value);
7. }
* at sfOutputEscaperObjectDecorator->__call('getCORGANIZACION', array())
in n/a line n/a ...
* at sfOutputEscaperIteratorDecorator->getCORGANIZACION()
in SF_ROOT_DIR\apps\frontend\modules\organizacion\templates\indexSuccess.php
line 24 ...
1. <?php foreach ($smis_sis_organizacions as
$smis_sis_organizacion): ?>
2. <tr>
3. <td><a href="<?php echo
url_for('organizacion/show?id_organizacion='.$smis_sis_organizacion->getIdOrganizacion())
?>"><?php echo $smis_sis_organizacion->getIdORGANIZACION() ?></a></td>
4. <td><?php echo $smis_sis_organizacion->getCORGANIZACION()
?></td>
5. <td><?php echo $smis_sis_organizacion->getDORGANIZACION()
?></td>
6. <td><?php echo $smis_sis_organizacion->getDDIRECCIONFISCAL()
?></td>
7. <td><?php echo $smis_sis_organizacion->getCRIF() ?></td>
* at
require('D:\dev\sfproject\apps\frontend\modules\organizacion\templates\indexSuccess.php')
in SF_ROOT_DIR\lib\vendor\symfony\lib\view\sfPHPView.class.php line 75 ...
1.
2. try
3. {
4. require($_sfFile);
5. }
6. catch (Exception $e)
7. {
* at
sfPHPView->renderFile('D:\dev\sfproject\apps\frontend\modules/ORGANIZACION/templates/indexSuccess.php')
in SF_ROOT_DIR\lib\vendor\symfony\lib\view\sfPHPView.class.php line 185 ...
1. $this->attributeHolder->set('sf_type', 'action');
2.
3. // render template file
4. $content =
$this->renderFile($this->getDirectory().'/'.$this->getTemplate());
5.
6. if (sfConfig::get('sf_cache') && null !== $uri)
7. {
* at sfPHPView->render()
in SF_ROOT_DIR\lib\vendor\symfony\lib\filter\sfExecutionFilter.class.php line
155 ...
1. break;
2.
3. case sfView::RENDER_CLIENT:
4. $viewData = $view->render();
5. $this->context->getResponse()->setContent($viewData);
6. break;
7.
* at sfExecutionFilter->executeView('ORGANIZACION', 'index', 'Success',
array('smis_sis_organizacions' => object('Doctrine_Collection')))
in SF_ROOT_DIR\lib\vendor\symfony\lib\filter\sfExecutionFilter.class.php line
116 ...
1. return;
2. }
3.
4. $this->executeView($actionInstance->getModuleName(),
$actionInstance->getActionName(), $viewName,
$actionInstance->getVarHolder()->getAll());
5. }
6.
7. /**
* at sfExecutionFilter->handleView(object('sfFilterChain'),
object('organizacionActions'), 'Success')
in SF_ROOT_DIR\lib\vendor\symfony\lib\filter\sfExecutionFilter.class.php line
47 ...
1. $timer->addTime();
2. $timer = sfTimerManager::getTimer(sprintf('View "%s" for
"%s/%s"', $viewName, $actionInstance->getModuleName(),
$actionInstance->getActionName()));
3.
4. $this->handleView($filterChain, $actionInstance, $viewName);
5.
6. $timer->addTime();
7. }
* at sfExecutionFilter->execute(object('sfFilterChain'))
in SF_ROOT_DIR\lib\vendor\symfony\lib\filter\sfFilterChain.class.php line 53 ...
1. }
2.
3. // execute the next filter
4. $this->chain[$this->index]->execute($this);
5. }
6. }
7.
* at sfFilterChain->execute()
in SF_ROOT_DIR\lib\vendor\symfony\lib\filter\sfRenderingFilter.class.php line
33 ...
1. public function execute($filterChain)
2. {
3. // execute next filter
4. $filterChain->execute();
5.
6. // get response object
7. $response = $this->context->getResponse();
* at sfRenderingFilter->execute(object('sfFilterChain'))
in SF_ROOT_DIR\lib\vendor\symfony\lib\filter\sfFilterChain.class.php line 53 ...
1. }
2.
3. // execute the next filter
4. $this->chain[$this->index]->execute($this);
5. }
6. }
7.
* at sfFilterChain->execute()
in SF_ROOT_DIR\lib\vendor\symfony\lib\controller\sfController.class.php line
233 ...
1. }
2.
3. // process the filter chain
4. $filterChain->execute();
5. }
6. else
7. {
* at sfController->forward('ORGANIZACION', 'index')
in SF_ROOT_DIR\lib\vendor\symfony\lib\controller\sfFrontWebController.class.php
line 48 ...
1. }
2.
3. // make the first request
4. $this->forward($moduleName, $actionName);
5. }
6. catch (sfException $e)
7. {
* at sfFrontWebController->dispatch()
in SF_ROOT_DIR\lib\vendor\symfony\lib\util\sfContext.class.php line 170 ...
1. */
2. public function dispatch()
3. {
4. $this->getController()->dispatch();
5. }
6.
7. /**
* at sfContext->dispatch()
in SF_ROOT_DIR\web\frontend_dev.php line 13 ...
1.
require_once(dirname(__FILE__).'/../config/ProjectConfiguration.class.php');
2.
3. $configuration =
ProjectConfiguration::getApplicationConfiguration('frontend', 'dev', true);
4. sfContext::createInstance($configuration)->dispatch();
5.
symfony settings ...
mod_organizacion_enabled: true
mod_organizacion_view_class: sfPHP
sf_admin_module_web_dir: /sfDoctrinePlugin
sf_admin_web_dir: /sf/sf_admin
sf_app: frontend
sf_app_base_cache_dir: 'D:\dev\sfproject\cache\frontend'
sf_app_cache_dir: 'D:\dev\sfproject\cache\frontend\dev'
sf_app_config_dir: 'D:\dev\sfproject\apps\frontend\config'
sf_app_dir: 'D:\dev\sfproject\apps\frontend'
sf_app_i18n_dir: 'D:\dev\sfproject\apps\frontend\i18n'
sf_app_lib_dir: 'D:\dev\sfproject\apps\frontend\lib'
sf_app_module_dir: 'D:\dev\sfproject\apps\frontend\modules'
sf_app_template_dir: 'D:\dev\sfproject\apps\frontend\templates'
sf_apps_dir: 'D:\dev\sfproject\apps'
sf_cache: false
sf_cache_dir: 'D:\dev\sfproject\cache'
sf_charset: utf-8
sf_check_lock: false
sf_compressed: false
sf_config_cache_dir: 'D:\dev\sfproject\cache\frontend\dev\config'
sf_config_dir: 'D:\dev\sfproject\config'
sf_csrf_secret: d420541b121a390461c7e714d0151b2f444c40db
sf_data_dir: 'D:\dev\sfproject\data'
sf_debug: true
sf_default_culture: en
sf_enabled_modules:
- default
sf_environment: dev
sf_error_404_action: error404
sf_error_404_module: default
sf_error_reporting: 8191
sf_escaping_method: ESC_SPECIALCHARS
sf_escaping_strategy: true
sf_etag: false
sf_file_link_format: null
sf_i18n: false
sf_i18n_cache_dir: 'D:\dev\sfproject\cache\frontend\dev\i18n'
sf_lib_dir: 'D:\dev\sfproject\lib'
sf_log_dir: 'D:\dev\sfproject\log'
sf_logging_enabled: true
sf_login_action: login
sf_login_module: default
sf_module_cache_dir: 'D:\dev\sfproject\cache\frontend\dev\modules'
sf_module_disabled_action: disabled
sf_module_disabled_module: default
sf_no_script_name: false
sf_orm: doctrine
sf_plugins_dir: 'D:\dev\sfproject\plugins'
sf_root_dir: 'D:\dev\sfproject'
sf_secure_action: secure
sf_secure_module: default
sf_standard_helpers:
- Partial
- Cache
sf_symfony_lib_dir: 'D:\dev\sfproject\lib\vendor\symfony\lib'
sf_template_cache_dir: 'D:\dev\sfproject\cache\frontend\dev\template'
sf_test_cache_dir: 'D:\dev\sfproject\cache\frontend\dev\test'
sf_test_dir: 'D:\dev\sfproject\test'
sf_upload_dir: 'D:\dev\sfproject\web\uploads'
sf_use_database: true
sf_web_debug: true
sf_web_debug_web_dir: /sf/sf_web_debug
sf_web_dir: 'D:\dev\sfproject\web'
request ...
options:
path_info_key: PATH_INFO
path_info_array: SERVER
default_format: null
logging: '1'
relative_url_root: null
formats: { txt: text/plain, js: [application/javascript,
application/x-javascript, text/javascript], css: text/css, json:
[application/json, application/x-json], xml: [text/xml, application/xml,
application/x-xml], rdf: application/rdf+xml, atom: application/atom+xml }
no_script_name: false
parameterHolder:
action: index
module: ORGANIZACION
attributeHolder:
sf_route: 'sfRoute Object()'
response ...
status:
code: 500
text: 'Internal Server Error'
options:
http_protocol: HTTP/1.1
logging: '1'
charset: utf-8
send_http_headers: true
content_type: 'text/html; charset=utf-8'
cookies: { }
httpHeaders:
Content-Type: 'text/html; charset=utf-8'
javascripts: { }
stylesheets:
main.css: { }
metas: { }
httpMetas:
Content-Type: 'text/html; charset=utf-8'
user ...
options:
auto_shutdown: false
culture: null
default_culture: en
use_flash: true
logging: '1'
timeout: 1800
attributeHolder: { }
culture: en
global vars ...
cookie: { }
env: { }
files: { }
get: { }
post: { }
server:
COMSPEC: 'C:\WINDOWS\system32\cmd.exe'
DOCUMENT_ROOT: 'D:/dev/sfproject/web'
GATEWAY_INTERFACE: CGI/1.1
HTTP_ACCEPT: 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8'
HTTP_ACCEPT_CHARSET: 'ISO-8859-1,utf-8;q=0.7,*;q=0.7'
HTTP_ACCEPT_ENCODING: 'gzip,deflate'
HTTP_ACCEPT_LANGUAGE: 'es-es,es;q=0.8,en-us;q=0.5,en;q=0.3'
HTTP_CONNECTION: keep-alive
HTTP_HOST: sm-143c0295bc7c
HTTP_KEEP_ALIVE: '115'
HTTP_USER_AGENT: 'Mozilla/5.0 (Windows; U; Windows NT 5.1; es-ES; rv:1.9.2.3)
Gecko/20100401 Firefox/3.6.3 (.NET CLR 3.5.30729)'
PATH:
'C:\php-5.2.13\;d:\dev\sfproject\lib\vendor\symfony\data\bin;E:\oracle\product\Client10g\bin;E:\oracle\product\10.2.0\db_1\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program
Files\Microsoft SQL Server\90\Tools\binn\;C:\Program
Files\TortoiseSVN\bin;C:\Program Files\Common Files\GTK\2.0\bin'
PATHEXT: .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
PATH_INFO: /ORGANIZACION
PATH_TRANSLATED: 'D:\dev\sfproject\web\ORGANIZACION'
PHP_SELF: /frontend_dev.php/ORGANIZACION
QUERY_STRING: ''
REMOTE_ADDR: 192.168.0.135
REMOTE_PORT: '4731'
REQUEST_METHOD: GET
REQUEST_TIME: 1275000361
REQUEST_URI: /frontend_dev.php/ORGANIZACION
SCRIPT_FILENAME: 'D:/dev/sfproject/web/frontend_dev.php'
SCRIPT_NAME: /frontend_dev.php
SERVER_ADDR: 192.168.0.135
SERVER_ADMIN: ad...@cantv.net
SERVER_NAME: sm-143c0295bc7c
SERVER_PORT: '80'
SERVER_PROTOCOL: HTTP/1.1
SERVER_SIGNATURE: "<address>Apache/2.0.63 (Win32) PHP/5.2.13 Server at
sm-143c0295bc7c Port 80</address>\n"
SERVER_SOFTWARE: 'Apache/2.0.63 (Win32) PHP/5.2.13'
SystemRoot: 'C:\WINDOWS'
WINDIR: 'C:\WINDOWS'
session: { }
symfony v.1.4.4 - php 5.2.13
--
If you want to report a vulnerability issue on symfony, please send it to
security at symfony-project.com
You received this message because you are subscribed to the Google
Groups "symfony users" group.
To post to this group, send email to symfony-users@googlegroups.com
To unsubscribe from this group, send email to
symfony-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
